{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","Direct Entry Setup","ABA Format"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":44,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":54,"n_cols":205,"rows_kept":54,"cut":false,"hidden":false,"merged":[[35,112,35,114],[4,62,4,66],[13,62,13,65],[4,2,4,5],[8,2,8,5],[15,8,15,9],[17,8,17,9],[16,8,16,9],[15,12,15,13],[17,10,17,11],[15,10,15,11],[22,2,22,3],[16,10,16,11],[16,12,16,13],[31,10,31,11],[32,10,32,11],[33,10,33,11],[34,10,34,11],[12,8,12,10],[18,8,18,9],[49,10,49,11],[50,10,50,11],[51,10,51,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[23,10,23,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,10,30,11],[52,10,52,11],[53,10,53,11],[35,10,35,11],[36,10,36,11],[37,10,37,11],[38,10,38,11],[39,10,39,11],[40,10,40,11],[41,10,41,11],[42,10,42,11],[43,10,43,11],[44,10,44,11],[45,10,45,11],[46,10,46,11],[47,10,47,11],[48,10,48,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEADER FORMAT CONTROL",null,null,null,null,null,null,null,{"$f":"IF(SUM(EP3:EY3)=0,\"ALL CELLS BLANK - READY FOR NEW DATA INPUT.\",IF(SUM(EP1:EY1)>0,\"ONE OR MORE CELLS ARE GREATER IN LENGTH THAN THEY SHOULD BE\",IF(SUM(EP2:EY2)>0,\"PADDING REQUIRED\",\"NOW CLICK ON 'PREPARE ABA FILE' BUTTON.\")))","v":"NOW CLICK ON 'PREPARE ABA FILE' BUTTON."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FINAL VALUE PADDED","POSITIVE PADDING","NEGATIVE PADDING",null,"Only use if Negative Padding Needed",null,null,null,null,null,{"$f":"IF(MAX(EP5:EP5)>DF3,1,0)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(SUM(EP1:EY1)>0,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLANK CELL FAST PADDING SECTION"]
[null,null,null,null,"www.abacreator.com",null,"Direct Entry",null,null,"Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(EP5:EP5)<DF3,1,0)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(SUM(EP2:EY2)>0,1,0)","v":0},null,"COPY THE CELLS IN THE COLOURED SECTION BELOW AND PASTE AS TEXT INTO A NEW SPREADSHEET, THEN SAVE THAT SPREADSHEET AS A 'TAB DELIMITED' .TXT FILE.",null,"working",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                                  ","<-- This pink cell is the cell with 50 spaces of BLANK"]
[null,null,null,"Version 2.21","sales@abacreator.com",null,null,null,null,"Choose Direct Entry Setup",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,17,2,3,7,26,6,12,6,40,null,null,null,{"$f":"IF(LEN(DF3)=DF$3,DF3,IF(LEN(DF3)<DF$3,CONCATENATE(DF3,\" \"),LEFT(DF3,DF$3)))","v":1},{"$f":"IF(LEN(DG3)=DG$3,DG3,IF(LEN(DG3)<DG$3,CONCATENATE(DG3,\" \"),LEFT(DG3,DG$3)))","v":"17 "},{"$f":"IF(LEN(DH3)=DH$3,DH3,IF(LEN(DH3)<DH$3,CONCATENATE(\" \",DH3),LEFT(DH3,DH$3)))","v":" 2"},{"$f":"IF(LEN(DI3)=DI$3,DI3,IF(LEN(DI3)<(DI$3-5),CONCATENATE(DI3,\"     \"),IF(LEN(DI3)<DI$3,CONCATENATE(DI3,\" \"),LEFT(DI3,DI$3))))","v":"3 "},{"$f":"IF(LEN(DJ3)=DJ$3,DJ3,IF(LEN(DJ3)<(DJ$3-5),CONCATENATE(DJ3,\"     \"),IF(LEN(DJ3)<DJ$3,CONCATENATE(DJ3,\" \"),LEFT(DJ3,DJ$3))))","v":"7     "},{"$f":"IF(LEN(DK3)=DK$3,DK3,IF(LEN(DK3)<DK$3,CONCATENATE(DK3,\" \"),LEFT(DK3,DK$3)))","v":"26 "},{"$f":"IF(LEN(DL3)=DL$3,DL3,IF(LEN(DL3)<DL$3,CONCATENATE(DL3,\" \"),LEFT(DL3,DL$3)))","v":"6 "},{"$f":"IF(LEN(DM3)=DM$3,DM3,IF(LEN(DM3)<DM$3,CONCATENATE(DM3,\" \"),LEFT(DM3,DM$3)))","v":"12 "},{"$f":"IF(LEN(DN3)=DN$3,DN3,IF(LEN(DN3)<DN$3,CONCATENATE(DN3,\" \"),LEFT(DN3,DN$3)))","v":"6 "},{"$f":"IF(LEN(DO3)=DO$3,DO3,IF(LEN(DO3)<DO$3,CONCATENATE(DO3,\" \"),LEFT(DO3,DO$3)))","v":"40 "},null,null,null,{"$f":"IF(EI3>0,EG3,IF(EI3<0,EH3,\"*ZERO VALUE*\"))","v":"2.00"},{"$f":"IF(EI3<0,\"\",IF(EN3=1,CONCATENATE(EI3,\".00\"),IF(EN3=3,CONCATENATE(EI3,\"0\"),IF(EN3=4,CONCATENATE(EI3)))))","v":"2.00"},{"$f":"IF(EI3>0,\"\",IF(EN3=1,CONCATENATE(EI3,\".00\"),IF(EN3=3,CONCATENATE(EI3,\"0\"),IF(EN3=4,CONCATENATE(EI3,\" \"),IF(EN3=5,CONCATENATE(EI3))))))","v":""},{"$f":"DH3*1","v":2},{"$f":"TRUNC(EI3)","v":2},{"$f":"ROUND((EI3-EJ3),2)","v":0},{"$f":"LEN(EI3)","v":1},{"$f":"LEN(EJ3)","v":1},{"$f":"LEN(EK3)","v":1},null,{"$f":"SUM(EP5:EP5)","v":1},17,2,3,7,26,6,12,6,40,null,null,null,{"$f":"SUM(FC5:FC5)","v":0},null,"THIS NEW TAB DELIMITED .TXT FILE CAN THEN BE USED TO UPLOAD TO THE BANK.",null,"area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DF3","v":1},17,2,3,7,26,6,12,6,40]
[null,null,null,{"$f":"IF('Direct Entry Setup'!U6=TRUE,\"Demo Version\",\"\")","v":"Demo Version"},"Copyright  © 2017 Roger Green. All Rights Reserved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rec Type","Blank","Reel Sequence","Name of Users Fin Institute","Blank","Name of use","Name of Use","Description e.g. PAYROLL","Date","Blank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORIGINAL NUMBER","NUMBER TRUNCATED","DIFF.","ORIG LENGTH","TRUNC. LENGTH","DIFF. LENGTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUTO MISSING CHARACTERS LENGTH CALCULATOR"]
[null,null,"Descriptive Record (Header)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Descriptive Record (Header)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0","                 ","01","WBC","       ","ABC Limited               ","012000","DEBTORS     ","310821","                                        ",null,null,null,{"$f":"IF(LEN(DF5)=DF$3,DF5,IF(LEN(DF5)<DF$3,CONCATENATE(DF5,\" \"),LEFT(DF5,DF$3)))","v":"0"},{"$f":"IF(LEN(DG5)=DG$3,DG5,IF(LEN(DG5)<DG$3,CONCATENATE(DG5,\" \"),LEFT(DG5,DG$3)))","v":"                 "},{"$f":"IF(LEN(DH5)=DH$3,DH5,IF(LEN(DH5)<DH$3,CONCATENATE(\" \",DH5),LEFT(DH5,DH$3)))","v":"01"},{"$f":"IF(LEN(DI5)=DI$3,DI5,IF(LEN(DI5)<(DI$3-5),CONCATENATE(DI5,\"     \"),IF(LEN(DI5)<DI$3,CONCATENATE(DI5,\" \"),LEFT(DI5,DI$3))))","v":"WBC"},{"$f":"IF(LEN(DJ5)=DJ$3,DJ5,IF(LEN(DJ5)<(DJ$3-5),CONCATENATE(DJ5,\"     \"),IF(LEN(DJ5)<DJ$3,CONCATENATE(DJ5,\" \"),LEFT(DJ5,DJ$3))))","v":"       "},{"$f":"IF(LEN(DK5)=DK$3,DK5,IF(LEN(DK5)<DK$3,CONCATENATE(DK5,\" \"),LEFT(DK5,DK$3)))","v":"ABC Limited               "},{"$f":"IF(LEN(DL5)=DL$3,DL5,IF(LEN(DL5)<DL$3,CONCATENATE(DL5,\" \"),LEFT(DL5,DL$3)))","v":"012000"},{"$f":"IF(LEN(DM5)=DM$3,DM5,IF(LEN(DM5)<DM$3,CONCATENATE(DM5,\" \"),LEFT(DM5,DM$3)))","v":"DEBTORS     "},{"$f":"IF(LEN(DN5)=DN$3,DN5,IF(LEN(DN5)<DN$3,CONCATENATE(DN5,\" \"),LEFT(DN5,DN$3)))","v":"310821"},{"$f":"IF(LEN(DO5)=DO$3,DO5,IF(LEN(DO5)<DO$3,CONCATENATE(DO5,\" \"),LEFT(DO5,DO$3)))","v":"                                        "},null,null,null,{"$f":"IF(EI5>0,EG5,IF(EI5<0,EH5,\"*ZERO VALUE*\"))","v":"1.00"},{"$f":"IF(EI5<0,\"\",IF(EN5=1,CONCATENATE(EI5,\".00\"),IF(EN5=3,CONCATENATE(EI5,\"0\"),IF(EN5=4,CONCATENATE(EI5)))))","v":"1.00"},{"$f":"IF(EI5>0,\"\",IF(EN5=1,CONCATENATE(EI5,\".00\"),IF(EN5=3,CONCATENATE(EI5,\"0\"),IF(EN5=4,CONCATENATE(EI5,\" \"),IF(EN5=5,CONCATENATE(EI5))))))","v":""},{"$f":"DH5*1","v":1},{"$f":"TRUNC(EI5)","v":1},{"$f":"ROUND((EI5-EJ5),2)","v":0},{"$f":"LEN(EI5)","v":1},{"$f":"LEN(EJ5)","v":1},{"$f":"LEN(EK5)","v":1},null,{"$f":"LEN(DF5)","v":1},17,2,3,7,26,6,12,6,40,null,null,null,{"$f":"IF(SUM(EP5:EY5)=0,0,IF(LEN(DF5)=0,1,IF(LEN(DG5)=0,1,IF(LEN(DH5)=0,1,0))))","v":0},null,{"$f":"IFERROR(FG5,\"\")","v":"0                 01WBC       ABC Limited               012000DEBTORS     310821                                        "},null,{"$f":"IFERROR(CONCATENATE(DF5,DG5,DH5,DI5,DJ5,DK5,DL5,DM5,DN5,DO5),\"\")","v":"0                 01WBC       ABC Limited               012000DEBTORS     310821                                        "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(DF5)=0,\"     \",CONCATENATE(DF5,GJ5))","v":"0"},{"$f":"IF(LEN(DG5)=0,\"\",DG5)","v":"                 "},{"$f":"IF(LEN(DH5)=0,\"                 \",CONCATENATE(DH5,GL5))","v":"01"},{"$f":"IF(LEN(DI5)=0,\"                 \",CONCATENATE(DI5,GM5))","v":"WBC"},{"$f":"IF(LEN(DJ5)=0,\"\",CONCATENATE(DJ5,GN5))","v":"       "},{"$f":"IF(LEN(DK5)=0,\"     \",CONCATENATE(DK5,GO5))","v":"ABC Limited               "},{"$f":"IF(LEN(DL5)=0,\"         \",CONCATENATE(DL5,GP5))","v":"012000"},{"$f":"IF(LEN(DM5)=0,\"   \",CONCATENATE(DM5,GQ5))","v":"DEBTORS     "},{"$f":"IF(LEN(DN5)=0,\"      \",CONCATENATE(DN5,GR5))","v":"310821"},{"$f":"IF(LEN(DO5)=0,\"      \",CONCATENATE(DO5,GS5))","v":"                                        "},null,{"$f":"LEFT($GI$2,(FY$3-LEN(DF5)))","v":""},{"$f":"RIGHT($GI$2,(FZ$3-LEN(DG5)))","v":""},{"$f":"RIGHT($GI$2,(GA$3-LEN(DH5)))","v":""},{"$f":"LEFT($GI$2,(GB$3-LEN(DI5)))","v":""},"","","","","",""]
[null," ","Financial Institution","User Preferred Specification","User Identification Number","Description e.g. PAYROLL",null,null,null,"Reset Input for new data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rec Type","Blank","Reel Sequence","Name of Users Fin Institute","Blank","User Preferred Specification","User ID","Description e.g. PAYROLL","Date","Blank"]
[null,null,{"$f":"VLOOKUP(DirectEntry,DirectEntryData,6,FALSE)","v":"WBC"},{"$f":"VLOOKUP(DirectEntry,DirectEntryData,2,FALSE)","v":"ABC Limited"},{"$f":"TEXT(VLOOKUP(DirectEntry,DirectEntryData,3,FALSE),\"000000\")","v":"030111"},{"$f":"VLOOKUP(DirectEntry,DirectEntryData,4,FALSE)","v":"CREDITORS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0","                 ","01",{"$f":"VLOOKUP(DirectEntry,DirectEntryData,6,FALSE)","v":"WBC"},"       ",{"$f":"VLOOKUP(DirectEntry,DirectEntryData,2,FALSE)","v":"ABC Limited"},{"$f":"TEXT(VLOOKUP(DirectEntry,DirectEntryData,3,FALSE),\"000000\")","v":"030111"},{"$f":"VLOOKUP(DirectEntry,DirectEntryData,4,FALSE)","v":"CREDITORS"},{"$f":"Date","v":"310821"},"                                        "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BODY FORMAT CONTROL",null,null,null,null,null,null,null,{"$f":"IF(SUM(EP10:FA10)=0,\"ALL CELLS BLANK - READY FOR NEW DATA INPUT.\",IF(SUM(EP8:FA8)>0,\"ONE OR MORE CELLS ARE GREATER IN LENGTH THAN THEY SHOULD BE\",IF(SUM(EP9:FA9)>0,\"PADDING REQUIRED\",\"NOW CLICK ON 'PREPARE ABA FILE' BUTTON.\")))","v":"NOW CLICK ON 'PREPARE ABA FILE' BUTTON."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FINAL VALUE PADDED","POSITIVE PADDING","NEGATIVE PADDING",null,null,null,null,null,null,null,{"$f":"IF(MAX(EP12:EP16)>DF10,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(SUM(EP8:FA8)>0,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLANK CELL FAST PADDING SECTION"]
[null,null,"Detail Records (Data)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(EP12:EP16)<DF10,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(SUM(EP9:FA9)>0,1,0)","v":0},null,null,null,"working",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                                  ","<-- This pink cell is the cell with 50 spaces of BLANK"]
[null,null,"Transaction Code","Trace Record BSB","Trace Record Account No.","Name of Remitter",null,null,null,"Make sure ABA Creator is the only Spreadsheet open",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7,9,1,2,11,32,18,7,9,16,8,null,{"$f":"IF(LEN(DF10)=DF$10,DF10,IF(LEN(DF10)<DF$10,CONCATENATE(DF10,\" \"),LEFT(DF10,DF$10)))","v":1},{"$f":"IF(LEN(DG10)=DG$10,DG10,IF(LEN(DG10)<DG$10,CONCATENATE(DG10,\" \"),LEFT(DG10,DG$10)))","v":"7 "},{"$f":"IF(LEN(DH10)=DH$10,DH10,IF(LEN(DH10)<DH$10,CONCATENATE(\" \",DH10),LEFT(DH10,DH$10)))","v":" 9"},{"$f":"IF(LEN(DI10)=DI$10,DI10,IF(LEN(DI10)<(DI$10-5),CONCATENATE(DI10,\"     \"),IF(LEN(DI10)<DI$10,CONCATENATE(DI10,\" \"),LEFT(DI10,DI$10))))","v":1},{"$f":"IF(LEN(DJ10)=DJ$10,DJ10,IF(LEN(DJ10)<(DJ$10-5),CONCATENATE(DJ10,\"     \"),IF(LEN(DJ10)<DJ$10,CONCATENATE(DJ10,\" \"),LEFT(DJ10,DJ$10))))","v":"2 "},{"$f":"IF(LEN(DK10)=DK$10,DK10,IF(LEN(DK10)<DK$10,CONCATENATE(DK10,\" \"),LEFT(DK10,DK$10)))","v":"11 "},"32 ","18 ","7 ","9 ","16 ","8 ",null,{"$f":"IF(EI10>0,EG10,IF(EI10<0,EH10,\"*ZERO VALUE*\"))","v":"9.00"},{"$f":"IF(EI10<0,\"\",IF(EN10=1,CONCATENATE(EI10,\".00\"),IF(EN10=3,CONCATENATE(EI10,\"0\"),IF(EN10=4,CONCATENATE(EI10)))))","v":"9.00"},{"$f":"IF(EI10>0,\"\",IF(EN10=1,CONCATENATE(EI10,\".00\"),IF(EN10=3,CONCATENATE(EI10,\"0\"),IF(EN10=4,CONCATENATE(EI10,\" \"),IF(EN10=5,CONCATENATE(EI10))))))","v":""},{"$f":"DH10*1","v":9},{"$f":"TRUNC(EI10)","v":9},{"$f":"ROUND((EI10-EJ10),2)","v":0},{"$f":"LEN(EI10)","v":1},{"$f":"LEN(EJ10)","v":1},{"$f":"LEN(EK10)","v":1},null,{"$f":"SUM(EP12:EP16)","v":5},35,45,5,10,55,160,90,35,45,80,40,null,{"$f":"SUM(FC12:FC16)","v":0},null,null,null,"area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DF10","v":1},7,9,1,2,11,32,18,7,9,16,8]
[null,null,{"$f":"VLOOKUP(DirectEntry,DirectEntryData,5,FALSE)","v":"50 Creditors"},{"$f":"VLOOKUP(DirectEntry,DirectEntryData,7,FALSE)","v":"032-500"},{"$f":"VLOOKUP(DirectEntry,DirectEntryData,8,FALSE)","v":123456},{"$f":"VLOOKUP(DirectEntry,DirectEntryData,10,FALSE)","v":"ABC Limited"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Record Type","BSB No","Account No","Indicator","Trans Code","AMOUNT","Account Name","Lodgement Reference","Trace Record","Account Number","Name of Remitter","Withholding Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORIGINAL NUMBER","NUMBER TRUNCATED","DIFF.","ORIG LENGTH","TRUNC. LENGTH","DIFF. LENGTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUTO MISSING CHARACTERS LENGTH CALCULATOR"]
[null,null,null,null,null,null,null,null,null,null,null,"Batch Number",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1","650-000","   123456"," ","13","100        ","Customer A                      ","Inv 01            ","032-500","   123456","ABC Limited     ","00000000",null,{"$f":"IF(LEN(DF12)=DF$10,DF12,IF(LEN(DF12)<DF$10,CONCATENATE(DF12,\" \"),LEFT(DF12,DF$10)))","v":"1"},{"$f":"IF(LEN(DG12)=DG$10,DG12,IF(LEN(DG12)<DG$10,CONCATENATE(DG12,\" \"),LEFT(DG12,DG$10)))","v":"650-000"},{"$f":"IF(LEN(DH12)=DH$10,DH12,IF(LEN(DH12)<DH$10,CONCATENATE(\" \",DH12),LEFT(DH12,DH$10)))","v":"   123456"},{"$f":"IF(LEN(DI12)=DI$10,DI12,IF(LEN(DI12)<(DI$10-5),CONCATENATE(DI12,\"     \"),IF(LEN(DI12)<DI$10,CONCATENATE(DI12,\" \"),LEFT(DI12,DI$10))))","v":" "},{"$f":"IF(LEN(DJ12)=DJ$10,DJ12,IF(LEN(DJ12)<(DJ$10-5),CONCATENATE(DJ12,\"     \"),IF(LEN(DJ12)<DJ$10,CONCATENATE(DJ12,\" \"),LEFT(DJ12,DJ$10))))","v":"13"},{"$f":"IF(LEN(DK12)=DK$10,DK12,IF(LEN(DK12)<DK$10,CONCATENATE(DK12,\" \"),LEFT(DK12,DK$10)))","v":"100        "},{"$f":"IF(LEN(DL12)=DL$10,DL12,IF(LEN(DL12)<DL$10,CONCATENATE(DL12,\" \"),LEFT(DL12,DL$10)))","v":"Customer A                      "},{"$f":"IF(LEN(DM12)=DM$10,DM12,IF(LEN(DM12)<DM$10,CONCATENATE(DM12,\" \"),LEFT(DM12,DM$10)))","v":"Inv 01            "},{"$f":"IF(LEN(DN12)=DN$10,DN12,IF(LEN(DN12)<DN$10,CONCATENATE(DN12,\" \"),LEFT(DN12,DN$10)))","v":"032-500"},{"$f":"IF(LEN(DO12)=DO$10,DO12,IF(LEN(DO12)<DO$10,CONCATENATE(DO12,\" \"),LEFT(DO12,DO$10)))","v":"   123456"},{"$f":"IF(LEN(DP12)=DP$10,DP12,IF(LEN(DP12)<DP$10,CONCATENATE(DP12,\" \"),LEFT(DP12,DP$10)))","v":"ABC Limited     "},{"$f":"IF(LEN(DQ12)=DQ$10,DQ12,IF(LEN(DQ12)<DQ$10,CONCATENATE(DQ12,\" \"),LEFT(DQ12,DQ$10)))","v":"00000000"},null,{"$f":"IF(EI12>0,EG12,IF(EI12<0,EH12,\"*ZERO VALUE*\"))","v":"123456.00"},{"$f":"IF(EI12<0,\"\",IF(EN12=1,CONCATENATE(EI12,\".00\"),IF(EN12=3,CONCATENATE(EI12,\"0\"),IF(EN12=4,CONCATENATE(EI12)))))","v":"123456.00"},{"$f":"IF(EI12>0,\"\",IF(EN12=1,CONCATENATE(EI12,\".00\"),IF(EN12=3,CONCATENATE(EI12,\"0\"),IF(EN12=4,CONCATENATE(EI12,\" \"),IF(EN12=5,CONCATENATE(EI12))))))","v":""},{"$f":"DH12*1","v":123456},{"$f":"TRUNC(EI12)","v":123456},{"$f":"ROUND((EI12-EJ12),2)","v":0},{"$f":"LEN(EI12)","v":6},6,1,null,{"$f":"LEN(DF12)","v":1},7,9,1,2,11,32,18,7,9,16,8,null,{"$f":"IF(SUM(EP12:FA12)=0,0,IF(LEN(DF12)=0,1,IF(LEN(DG12)=0,1,IF(LEN(DH12)=0,1,0))))","v":0},null,{"$f":"IFERROR(FG12,\"\")","v":"1650-000   123456 130000010000Customer A                      Inv 01            032-500   123456ABC Limited     00000000"},null,{"$f":"IFERROR(CONCATENATE(DF12,DG12,DH12,DI12,DJ12,TEXT(DK12*100,\"0000000000\"),DL12,DM12,DN12,DO12,DP12,DQ12),\"\")","v":"1650-000   123456 130000010000Customer A                      Inv 01            032-500   123456ABC Limited     00000000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(DF12)=0,\"     \",CONCATENATE(DF12,GL12))","v":"1"},{"$f":"IF(LEN(DG12)=0,\"\",DG12)","v":"650-000"},{"$f":"IF(LEN(DH12)=0,\"           \",CONCATENATE(RIGHT(REPT(\" \",9)&DH12,9),GN12))","v":"   123456"},{"$f":"IF(LEN(DI12)=0,\"                 \",CONCATENATE(DI12,GO12))","v":" "},{"$f":"IF(LEN(DJ12)=0,\"                                                 \",CONCATENATE(DJ12,GP12))","v":"13"},{"$f":"IF(LEN(DK12)=0,\"     \",CONCATENATE(DK12,GQ12))","v":"100        "},{"$f":"IF(LEN(DL12)=0,\"         \",CONCATENATE(DL12,GR12))","v":"Customer A                      "},{"$f":"IF(LEN(DM12)=0,\"   \",CONCATENATE(DM12,GS12))","v":"Inv 01            "},{"$f":"IF(LEN(DN12)=0,\"      \",CONCATENATE(DN12,GT12))","v":"032-500"},{"$f":"IF(LEN(DO12)=0,\"   \",CONCATENATE(RIGHT(REPT(\" \",9)&DO12,9),GU12))","v":"   123456"},{"$f":"IF(LEN(DP12)=0,\"  \",CONCATENATE(DP12,GV12))","v":"ABC Limited     "},{"$f":"IF(LEN(DQ12)=0,\" \",DQ12)","v":"00000000"},null,{"$f":"LEFT($GK$9,(FY$10-LEN(DF12)))","v":""},{"$f":"RIGHT($GK$9,(FZ$10-LEN(DG12)))","v":""},{"$f":"RIGHT($GK$9,(GA$10-LEN(DH12)))","v":""},{"$f":"LEFT($GK$9,(GB$10-LEN(DI12)))","v":""},"","","","","","","",""]
[null,null,{"$f":"INDEX(DirectEntryData,'Direct Entry Setup'!$U$4,1)","v":"ABC Limited - Creditors"},null,{"$f":"SUM(F16:F19)","v":450},"Date","310821",null,{"$f":"IF(LEN(G13)<>6,\"       ←   enter date format as DDMMYY    e.g. 310321\",IF(C16=\"\",\"     ↙   enter or paste data values in light blue cells below\",\"\"))","v":""},null,null,"2021-821",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1","650-000","   123456"," ","13","110        ","Customer B                      ","Inv 02            ","032-500","   123456","ABC Limited     ","00000000",null,"1","650-000","   123456"," ","13","110        ","Customer B                      ","Inv 02            ","032-500","   123456","ABC Limited     ","00000000",null,"123456.00","123456.00","",123456,123456,0,6,6,1,null,1,7,9,1,2,11,32,18,7,9,16,8,null,0,null,"1650-000   123456 130000011000Customer B                      Inv 02            032-500   123456ABC Limited     00000000",null,{"$f":"IFERROR(CONCATENATE(DF13,DG13,DH13,DI13,DJ13,TEXT(DK13*100,\"0000000000\"),DL13,DM13,DN13,DO13,DP13,DQ13),\"\")","v":"1650-000   123456 130000011000Customer B                      Inv 02            032-500   123456ABC Limited     00000000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1",{"$f":"IF(LEN(DG13)=0,\"\",DG13)","v":"650-000"},{"$f":"IF(LEN(DH13)=0,\"           \",CONCATENATE(RIGHT(REPT(\" \",9)&DH13,9),GN13))","v":"   123456"}," ","13","110        ","Customer B                      ","Inv 02            ","032-500",{"$f":"IF(LEN(DO13)=0,\"   \",CONCATENATE(RIGHT(REPT(\" \",9)&DO13,9),GU13))","v":"   123456"},"ABC Limited     ","00000000",null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Detail Records (Data)",null,null,null,{"$f":"VLOOKUP(DirectEntry,DirectEntryData,5,FALSE)","v":"50 Creditors"},null,null,null,{"$f":"VLOOKUP(DirectEntry,DirectEntryData,7,FALSE)","v":"032-500"},{"$f":"VLOOKUP(DirectEntry,DirectEntryData,8,FALSE)","v":123456},{"$f":"VLOOKUP(DirectEntry,DirectEntryData,10,FALSE)","v":"ABC Limited"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1","650-000","   123456"," ","13","120        ","Customer C                      ","Inv 03            ","032-500","   123456","ABC Limited     ","00000000",null,"1","650-000","   123456"," ","13","120        ","Customer C                      ","Inv 03            ","032-500","   123456","ABC Limited     ","00000000",null,"123456.00","123456.00","",123456,123456,0,6,6,1,null,1,7,9,1,2,11,32,18,7,9,16,8,null,0,null,"1650-000   123456 130000012000Customer C                      Inv 03            032-500   123456ABC Limited     00000000",null,"1650-000   123456 130000012000Customer C                      Inv 03            032-500   123456ABC Limited     00000000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1","650-000",{"$f":"IF(LEN(DH14)=0,\"           \",CONCATENATE(RIGHT(REPT(\" \",9)&DH14,9),GN14))","v":"   123456"}," ","13","120        ","Customer C                      ","Inv 03            ","032-500","   123456","ABC Limited     ","00000000",null,"","","","","","","","","","","",""]
[null,null,"BSB No","Account No","Account Name","AMOUNT","Lodgement Reference",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Record Type","BSB No","Account No","Indicator","Trans Code","AMOUNT","Account Name","Lodgement Reference","Trace Record","Account Number","Name of Remitter","Withholding Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1","650-000","   123456"," ","13","120        ","Customer C                      ","Inv 04            ","032-500","   123456","ABC Limited     ","00000000",null,"1","650-000","   123456"," ","13","120        ","Customer C                      ","Inv 04            ","032-500","   123456","ABC Limited     ","00000000",null,"123456.00","123456.00","",123456,123456,0,6,6,1,null,1,7,9,1,2,11,32,18,7,9,16,8,null,0,null,"1650-000   123456 130000012000Customer C                      Inv 04            032-500   123456ABC Limited     00000000",null,"1650-000   123456 130000012000Customer C                      Inv 04            032-500   123456ABC Limited     00000000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1","650-000","   123456"," ","13","120        ","Customer C                      ","Inv 04            ","032-500","   123456","ABC Limited     ","00000000",null,"","","","","","","","","","","",""]
[null,null,650000,"123456","Customer A",100,"Inv 01",null,{"$f":"IF(LEN(D16)>9,\"Account Number is limited to 9 characters\",IF(LEN(E16)>32,\"Account Name is limited to 32 characters\",IF(LEN(G16)>18,\"Lodgement Reference is limited to 18 characters\",IF('Direct Entry Setup'!$U$6=TRUE,\"Demo Version is limited to 4 lines\",\"\"))))","v":"Demo Version is limited to 4 lines"},null,{"$f":"IF(C16=\"\",\"\",IF(AND(C16>999,C16<999999),\"\",\"Invalid Format for BSB Number try ######\"))","v":""},null,{"$f":"IF(ISNUMBER(SEARCH(\",\",E16))=TRUE,\"Remove comma from Account Name\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F16=\"\",\"\",1)","v":1},{"$f":"IF(F16=\"\",\"\",IF(LEN(C16)=7,+C16,IF(LEN(C16)=6,MID(C16,1,3)&\"-\"&MID(C16,4,3),IF(LEN(C16)=5,MID((RIGHT(REPT(0,6)&C16,6)),1,3)&\"-\"&MID((RIGHT(REPT(0,6)&C16,6)),4,3),\"\"))))","v":"650-000"},{"$f":"IF(F16=\"\",\"\",+D16)","v":"123456"},null,{"$f":"IF(F16=\"\",\"\",+MID($BO$14,1,2))","v":"50"},{"$f":"IF(F16=\"\",\"\",VALUE(F16))","v":100},{"$f":"IF(F16=\"\",\"\",+E16)","v":"Customer A"},{"$f":"IF(F16=\"\",\"\",+G16)","v":"Inv 01"},{"$f":"IF(F16=\"\",\"\",IF(LEN($BS$14)=7,+$BS$14,IF(LEN($BS$14)=6,MID($BS$14,1,3)&\"-\"&MID($BS$14,4,3),IF(LEN($BS$14)=5,MID((RIGHT(REPT(0,6)&$BS$14,6)),1,3)&\"-\"&MID((RIGHT(REPT(0,6)&$BS$14,6)),4,3),\"\"))))","v":"032-500"},{"$f":"IF(F16=\"\",\"\",+$BT$14)","v":123456},{"$f":"IF(F16=\"\",\"\",+$BU$14)","v":"ABC Limited"},{"$f":"IF(F16=\"\",\"\",\"00000000\")","v":"00000000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1","032-500","   123456"," ","50","450        ","ABC Limited                     ","2021-821          ","032-500","   123456","ABC Limited     ","00000000",null,"1","032-500","   123456"," ","50","450        ","ABC Limited                     ","2021-821          ","032-500","   123456","ABC Limited     ","00000000",null,"123456.00","123456.00","",123456,123456,0,6,6,1,null,1,7,9,1,2,11,32,18,7,9,16,8,null,0,null,"1032-500   123456 500000045000ABC Limited                     2021-821          032-500   123456ABC Limited     00000000",null,"1032-500   123456 500000045000ABC Limited                     2021-821          032-500   123456ABC Limited     00000000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1","032-500","   123456"," ","50","450        ","ABC Limited                     ","2021-821          ","032-500","   123456","ABC Limited     ","00000000",null,"","","","","","","","","","","",""]
[null,null,650000,"123456","Customer B",110,"Inv 02",null,{"$f":"IF(LEN(D17)>9,\"Account Number is limited to 9 characters\",IF(LEN(E17)>32,\"Account Name is limited to 32 characters\",IF(LEN(G17)>18,\"Lodgement Reference is limited to 18 characters\",\"\")))","v":""},null,{"$f":"IF(C17=\"\",\"\",IF(AND(C17>999,C17<999999),\"\",\"Invalid Format for BSB Number try ######\"))","v":""},null,{"$f":"IF(ISNUMBER(SEARCH(\",\",E17))=TRUE,\"Remove comma from Account Name\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F17=\"\",\"\",1)","v":1},{"$f":"IF(F17=\"\",\"\",IF(LEN(C17)=7,+C17,IF(LEN(C17)=6,MID(C17,1,3)&\"-\"&MID(C17,4,3),IF(LEN(C17)=5,MID((RIGHT(REPT(0,6)&C17,6)),1,3)&\"-\"&MID((RIGHT(REPT(0,6)&C17,6)),4,3),\"\"))))","v":"650-000"},{"$f":"IF(F17=\"\",\"\",+D17)","v":"123456"},null,{"$f":"IF(F17=\"\",\"\",+MID($BO$14,1,2))","v":"50"},{"$f":"IF(F17=\"\",\"\",VALUE(F17))","v":110},{"$f":"IF(F17=\"\",\"\",+E17)","v":"Customer B"},{"$f":"IF(F17=\"\",\"\",+G17)","v":"Inv 02"},{"$f":"IF(F17=\"\",\"\",IF(LEN($BS$14)=7,+$BS$14,IF(LEN($BS$14)=6,MID($BS$14,1,3)&\"-\"&MID($BS$14,4,3),IF(LEN($BS$14)=5,MID((RIGHT(REPT(0,6)&$BS$14,6)),1,3)&\"-\"&MID((RIGHT(REPT(0,6)&$BS$14,6)),4,3),\"\"))))","v":"032-500"},{"$f":"IF(F17=\"\",\"\",+$BT$14)","v":123456},{"$f":"IF(F17=\"\",\"\",+$BU$14)","v":"ABC Limited"},{"$f":"IF(F17=\"\",\"\",\"00000000\")","v":"00000000"}]
[null,null,650000,"123456","Customer C",120,"Inv 03",null,{"$f":"IF(LEN(D18)>9,\"Account Number is limited to 9 characters\",IF(LEN(E18)>32,\"Account Name is limited to 32 characters\",IF(LEN(G18)>18,\"Lodgement Reference is limited to 18 characters\",\"\")))","v":""},null,{"$f":"IF(C18=\"\",\"\",IF(AND(C18>999,C18<999999),\"\",\"Invalid Format for BSB Number try ######\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F18=\"\",\"\",1)","v":1},{"$f":"IF(F18=\"\",\"\",IF(LEN(C18)=7,+C18,IF(LEN(C18)=6,MID(C18,1,3)&\"-\"&MID(C18,4,3),IF(LEN(C18)=5,MID((RIGHT(REPT(0,6)&C18,6)),1,3)&\"-\"&MID((RIGHT(REPT(0,6)&C18,6)),4,3),\"\"))))","v":"650-000"},{"$f":"IF(F18=\"\",\"\",+D18)","v":"123456"},null,{"$f":"IF(F18=\"\",\"\",+MID($BO$14,1,2))","v":"50"},{"$f":"IF(F18=\"\",\"\",VALUE(F18))","v":120},{"$f":"IF(F18=\"\",\"\",+E18)","v":"Customer C"},{"$f":"IF(F18=\"\",\"\",+G18)","v":"Inv 03"},{"$f":"IF(F18=\"\",\"\",IF(LEN($BS$14)=7,+$BS$14,IF(LEN($BS$14)=6,MID($BS$14,1,3)&\"-\"&MID($BS$14,4,3),IF(LEN($BS$14)=5,MID((RIGHT(REPT(0,6)&$BS$14,6)),1,3)&\"-\"&MID((RIGHT(REPT(0,6)&$BS$14,6)),4,3),\"\"))))","v":"032-500"},{"$f":"IF(F18=\"\",\"\",+$BT$14)","v":123456},{"$f":"IF(F18=\"\",\"\",+$BU$14)","v":"ABC Limited"},{"$f":"IF(F18=\"\",\"\",\"00000000\")","v":"00000000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOOTER FORMAT CONTROL",null,null,null,null,null,null,null,{"$f":"IF(SUM(EP20:EX20)=0,\"ALL CELLS BLANK - READY FOR NEW DATA INPUT.\",IF(SUM(EP18:EX18)>0,\"ONE OR MORE CELLS ARE GREATER IN LENGTH THAN THEY SHOULD BE\",IF(SUM(EP19:EX19)>0,\"PADDING REQUIRED\",\"NOW CLICK ON 'PREPARE ABA FILE' BUTTON.\")))","v":"PADDING REQUIRED"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FINAL VALUE PADDED","POSITIVE PADDING","NEGATIVE PADDING",null,null,null,null,null,null,null,{"$f":"IF(MAX(EP22:EP22)>DF20,1,0)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(SUM(EP18:EX18)>0,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLANK CELL FAST PADDING SECTION"]
[null,null,650000,"123456","Customer C",120,"Inv 04",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"650-000","123456",null,"50",120,"Customer C","Inv 04","032-500",123456,"ABC Limited","00000000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(EP22:EP22)<DF20,1,0)","v":0},0,0,1,1,1,0,0,0,null,null,null,null,{"$f":"IF(SUM(EP19:EX19)>0,1,0)","v":1},null,null,null,"working",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                                  ","<-- This pink cell is the cell with 50 spaces of BLANK"]
[null,null,{"$f":"IF('Direct Entry Setup'!$U$5=\"Y\",+$BS$14,\"\")","v":""},{"$f":"IF('Direct Entry Setup'!$U$5=\"Y\",+$BT$14,\"\")","v":""},{"$f":"IF('Direct Entry Setup'!$U$5=\"Y\",+$D$7,\"\")","v":""},{"$f":"IF('Direct Entry Setup'!$U$5=\"Y\",SUM($F$16:$F$19),\"\")","v":""},{"$f":"IF('Direct Entry Setup'!$U$5=\"Y\",+$E$7&\"-\"&MID(Date,1,2)&\"/\"&MID(Date,3,2)&\"/\"&MID(Date,5,2),\"\")","v":""},null,"SELF BALANCING LINE (only If required)",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,{"$f":"IF('Direct Entry Setup'!$U$5=\"Y\",IF(VLOOKUP(DirectEntry,DirectEntryData,4,FALSE)=\"CREDITORS\",13,IF(VLOOKUP(DirectEntry,DirectEntryData,4,FALSE)=\"PAYROLL\",13,IF(VLOOKUP(DirectEntry,DirectEntryData,4,FALSE)=\"DEBTORS\",50,\"\"))),\"\")","v":""},"","",{"$f":"IF(F20=\"\",\"\",+Batch)","v":""},{"$f":"IF(F20=\"\",\"\",IF(LEN($BS$14)=7,+$BS$14,IF(LEN($BS$14)=6,MID($BS$14,1,3)&\"-\"&MID($BS$14,4,3),IF(LEN($BS$14)=5,MID((RIGHT(REPT(0,6)&$BS$14,6)),1,3)&\"-\"&MID((RIGHT(REPT(0,6)&$BS$14,6)),4,3),\"\"))))","v":""},{"$f":"IF(F20=\"\",\"\",+$BT$14)","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7,12,11,11,10,24,6,40,null,null,null,null,{"$f":"IF(LEN(DF20)=DF$20,DF20,IF(LEN(DF20)<DF$20,CONCATENATE(DF20,\" \"),LEFT(DF20,DF$20)))","v":1},{"$f":"IF(LEN(DG20)=DG$20,DG20,IF(LEN(DG20)<DG$20,CONCATENATE(DG20,\" \"),LEFT(DG20,DG$20)))","v":"7 "},{"$f":"IF(LEN(DH20)=DH$20,DH20,IF(LEN(DH20)<DH$20,CONCATENATE(\" \",DH20),LEFT(DH20,DH$20)))","v":" 12"},{"$f":"IF(LEN(DI20)=DI$20,DI20,IF(LEN(DI20)<(DI$20-5),CONCATENATE(DI20,\"     \"),IF(LEN(DI20)<DI$20,CONCATENATE(DI20,\" \"),LEFT(DI20,DI$20))))","v":"11     "},{"$f":"IF(LEN(DJ20)=DJ$20,DJ20,IF(LEN(DJ20)<(DJ$20-5),CONCATENATE(DJ20,\"     \"),IF(LEN(DJ20)<DJ$20,CONCATENATE(DJ20,\" \"),LEFT(DJ20,DJ$20))))","v":"11     "},{"$f":"IF(LEN(DK20)=DK$20,DK20,IF(LEN(DK20)<DK$20,CONCATENATE(DK20,\" \"),LEFT(DK20,DK$20)))","v":"10 "},{"$f":"IF(LEN(DL20)=DL$20,DL20,IF(LEN(DL20)<DL$20,CONCATENATE(DL20,\" \"),LEFT(DL20,DL$20)))","v":"24 "},{"$f":"IF(LEN(DM20)=DM$20,DM20,IF(LEN(DM20)<DM$20,CONCATENATE(DM20,\" \"),LEFT(DM20,DM$20)))","v":"6 "},{"$f":"IF(LEN(DN20)=DN$20,DN20,IF(LEN(DN20)<DN$20,CONCATENATE(DN20,\" \"),LEFT(DN20,DN$20)))","v":"40 "},null,null,null,null,{"$f":"IF(EI20>0,EG20,IF(EI20<0,EH20,\"*ZERO VALUE*\"))","v":"12.00"},{"$f":"IF(EI20<0,\"\",IF(EN20=1,CONCATENATE(EI20,\".00\"),IF(EN20=3,CONCATENATE(EI20,\"0\"),IF(EN20=4,CONCATENATE(EI20)))))","v":"12.00"},{"$f":"IF(EI20>0,\"\",IF(EN20=1,CONCATENATE(EI20,\".00\"),IF(EN20=3,CONCATENATE(EI20,\"0\"),IF(EN20=4,CONCATENATE(EI20,\" \"),IF(EN20=5,CONCATENATE(EI20))))))","v":""},{"$f":"DH20*1","v":12},{"$f":"TRUNC(EI20)","v":12},{"$f":"ROUND((EI20-EJ20),2)","v":0},{"$f":"LEN(EI20)","v":2},{"$f":"LEN(EJ20)","v":2},{"$f":"LEN(EK20)","v":1},null,{"$f":"SUM(EP22:EP22)","v":1},7,12,1,3,3,24,6,40,null,null,null,null,{"$f":"SUM(FC22:FC22)","v":0},null,null,null,"area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DF20","v":1},7,12,11,11,10,24,6,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Record Type","BSB Format Filler","Blank","Net Total Amt","Credit Total Amt","Debit Total Amt","Blank","Record Count","Blank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORIGINAL NUMBER","NUMBER TRUNCATED","DIFF.","ORIG LENGTH","TRUNC. LENGTH","DIFF. LENGTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUTO MISSING CHARACTERS LENGTH CALCULATOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Total Record Footer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"999-999","            ",0,450,450,"                        ","000005","                                        ",null,null,null,null,{"$f":"IF(LEN(DF22)=DF$20,DF22,IF(LEN(DF22)<DF$20,CONCATENATE(DF22,\" \"),LEFT(DF22,DF$20)))","v":7},{"$f":"IF(LEN(DG22)=DG$20,DG22,IF(LEN(DG22)<DG$20,CONCATENATE(DG22,\" \"),LEFT(DG22,DG$20)))","v":"999-999"},{"$f":"IF(LEN(DH22)=DH$20,DH22,IF(LEN(DH22)<DH$20,CONCATENATE(\" \",DH22),LEFT(DH22,DH$20)))","v":"            "},{"$f":"IF(LEN(DI22)=DI$20,DI22,IF(LEN(DI22)<(DI$20-5),CONCATENATE(DI22,\"     \"),IF(LEN(DI22)<DI$20,CONCATENATE(DI22,\" \"),LEFT(DI22,DI$20))))","v":"0     "},{"$f":"IF(LEN(DJ22)=DJ$20,DJ22,IF(LEN(DJ22)<(DJ$20-5),CONCATENATE(DJ22,\"     \"),IF(LEN(DJ22)<DJ$20,CONCATENATE(DJ22,\" \"),LEFT(DJ22,DJ$20))))","v":"450     "},{"$f":"IF(LEN(DK22)=DK$20,DK22,IF(LEN(DK22)<DK$20,CONCATENATE(DK22,\" \"),LEFT(DK22,DK$20)))","v":"450 "},{"$f":"IF(LEN(DL22)=DL$20,DL22,IF(LEN(DL22)<DL$20,CONCATENATE(DL22,\" \"),LEFT(DL22,DL$20)))","v":"                        "},{"$f":"IF(LEN(DM22)=DM$20,DM22,IF(LEN(DM22)<DM$20,CONCATENATE(DM22,\" \"),LEFT(DM22,DM$20)))","v":"000005"},{"$f":"IF(LEN(DN22)=DN$20,DN22,IF(LEN(DN22)<DN$20,CONCATENATE(DN22,\" \"),LEFT(DN22,DN$20)))","v":"                                        "},null,null,null,null,{"$f":"IF(EI22>0,EG22,IF(EI22<0,EH22,\"*ZERO VALUE*\"))","v":{"$error":"#VALUE!"}},{"$f":"IF(EI22<0,\"\",IF(EN22=1,CONCATENATE(EI22,\".00\"),IF(EN22=3,CONCATENATE(EI22,\"0\"),IF(EN22=4,CONCATENATE(EI22)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(EI22>0,\"\",IF(EN22=1,CONCATENATE(EI22,\".00\"),IF(EN22=3,CONCATENATE(EI22,\"0\"),IF(EN22=4,CONCATENATE(EI22,\" \"),IF(EN22=5,CONCATENATE(EI22))))))","v":{"$error":"#VALUE!"}},{"$f":"DH22*1","v":{"$error":"#VALUE!"}},{"$f":"TRUNC(EI22)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((EI22-EJ22),2)","v":{"$error":"#VALUE!"}},{"$f":"LEN(EI22)","v":{"$error":"#VALUE!"}},{"$f":"LEN(EJ22)","v":{"$error":"#VALUE!"}},{"$f":"LEN(EK22)","v":{"$error":"#VALUE!"}},null,{"$f":"LEN(DF22)","v":1},7,12,1,3,3,24,6,40,null,null,null,null,{"$f":"IF(SUM(EP22:EX22)=0,0,IF(LEN(DF22)=0,1,IF(LEN(DG22)=0,1,IF(LEN(DH22)=0,1,0))))","v":0},null,{"$f":"IFERROR(FG22,\"\")","v":"7999-999            000000000000000450000000045000                        000005                                        "},null,{"$f":"IFERROR(CONCATENATE(DF22,DG22,DH22,TEXT(DI22*100,\"0000000000\"),TEXT(DJ22*100,\"0000000000\"),TEXT(DK22*100,\"0000000000\"),DL22,DM22,DN22),\"\")","v":"7999-999            000000000000000450000000045000                        000005                                        "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(DF22)=0,\"     \",CONCATENATE(DF22,GI22))","v":"7"},{"$f":"IF(LEN(DG22)=0,\"\",DG22)","v":"999-999"},{"$f":"IF(LEN(DH22)=0,\"                 \",CONCATENATE(DH22,GK22))","v":"            "},{"$f":"IF(LEN(DI22)=0,\"                 \",CONCATENATE(DI22,GL22))","v":"0          "},{"$f":"IF(LEN(DJ22)=0,\"                                                 \",CONCATENATE(DJ22,GM22))","v":"450        "},{"$f":"IF(LEN(DK22)=0,\"     \",CONCATENATE(DK22,GN22))","v":"450       "},{"$f":"IF(LEN(DL22)=0,\"         \",CONCATENATE(DL22,GO22))","v":"                        "},{"$f":"IF(LEN(DM22)=0,\"   \",CONCATENATE(RIGHT(REPT(0,6)&DM22,6),GP22))","v":"000005"},{"$f":"IF(LEN(DN22)=0,\"      \",CONCATENATE(DN22,GQ22))","v":"                                        "},null,{"$f":"LEFT($GH$19,(FY$20-LEN(DF22)))","v":""},{"$f":"RIGHT($GH$19,(FZ$20-LEN(DG22)))","v":""},{"$f":"RIGHT($GH$19,(GA$20-LEN(DH22)))","v":""},{"$f":"LEFT($GH$19,(GB$20-LEN(DI22)))","v":"          "},"        ","       ","","",""]
[null,null,"File Total Record Footer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Record Type","BSB Format Filler","Blank","Net Total Amt","Credit Total Amt","Debit Total Amt","Blank","Record Count","Blank"]
[null,null,"Net Total Amt",{"$f":"IF(D26>0,+D26-D25,+D25-D26)","v":450},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"999-999","            ",{"$f":"+D24","v":450},{"$f":"+D25","v":450},{"$f":"+D26","v":0},"                        ",{"$f":"TEXT(+D27,\"000000\")","v":"000004"},"                                        "]
[null,null,"Credit Total Amt",{"$f":"SUM($BP$16:$BP$20)-D26","v":450}]
[null,null,"Debit Total Amt",{"$f":"SUMIF($BO$16:$BO$20,13,$BP$16:$BP$20)","v":0}]
[null,null,"Record Count",{"$f":"COUNT(F16:F20)","v":4}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Direct Entry Setup","index":1,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,2,18,3],[6,2,6,3],[19,2,19,3],[20,2,20,3],[4,6,4,8]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lookup Tables"]
[null,null,"www.abacreator.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dropdown Choice",null,1,{"$f":"INDEX(DirectEntryData,$U$4,1)","v":"ABC Limited - Creditors"}]
[null,{"$f":"+Input!D3","v":"Version 2.21"},"sales@abacreator.com",null,"Direct Entry Setup Table",null,"     ↙   user updated fields in light blue cells below",null,null,null,null,null,null,null,null,null,null,null,"Add Self Balancing Line",null,{"$f":"VLOOKUP(DirectEntry,DirectEntryData,9,FALSE)","v":"N"}]
[null,{"$f":"IF('Direct Entry Setup'!U6=TRUE,\"Demo Version\",\"\")","v":"Demo Version"},"Copyright  © 2017 Roger Green. All Rights Reserved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[null,"Direct Entry Description","User Preferred Specification","User ID","Description e.g. PAYROLL","Transaction Code","Financial Institution","Trace Record BSB","Trace Record Account No.","Include Self Balancing Line","Name of Remitter"]
[null,{"$f":"K9&\" - \"&MID(F9,4,15)","v":"ABC Limited - Creditors"},"ABC Limited",30111,"CREDITORS","50 Creditors","WBC","032-500",123456,"N","ABC Limited",{"$f":"IF(LEN('Direct Entry Setup'!C9)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E9)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K9)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G9)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,{"$f":"K10&\" - \"&MID(F10,4,15)","v":"ABC Limited - Payroll"},"ABC Limited",88800,"PAYROLL","53 Payroll","WBC","032-500",123456,"N","ABC Limited",{"$f":"IF(LEN('Direct Entry Setup'!C10)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E10)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K10)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G10)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,"ABC Limited - Direct Debit","ABC Limited",12000,"DEBTORS","13 Direct Debit","WBC","032-500",123456,"N","ABC Limited",{"$f":"IF(LEN('Direct Entry Setup'!C11)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E11)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K11)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G11)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Direct Entry Setup'!C12)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E12)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K12)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G12)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Direct Entry Setup'!C13)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E13)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K13)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G13)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Direct Entry Setup'!C14)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E14)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K14)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G14)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Direct Entry Setup'!C15)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E15)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K15)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G15)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Direct Entry Setup'!C16)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E16)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K16)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G16)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Direct Entry Setup'!C17)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E17)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K17)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G17)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN('Direct Entry Setup'!C18)>26,\"User Preferred Specification limited to 26 characters\",IF(LEN('Direct Entry Setup'!E18)>12,\"Description limited to 12 characters\",IF(LEN('Direct Entry Setup'!K18)>16,\"Name of Remitter limited to 16 characters\",IF(LEN('Direct Entry Setup'!G18)>3,\"Financial Institution limited to 3 characters\",\"\"))))","v":""}]
[null,null,{"$f":"IF('Direct Entry Setup'!$U$6=TRUE,\"Demo Version is limited to Dummy Company\",\"\")","v":"Demo Version is limited to Dummy Company"}]
[null,null,{"$f":"IF('Direct Entry Setup'!$U$6=TRUE,\"Please supply your UPS and User ID at time of\",\"\")","v":"Please supply your UPS and User ID at time of"}]
[null,null,{"$f":"IF('Direct Entry Setup'!$U$6=TRUE,\"Order.  File will then be updated and emailed.\",\"\")","v":"Order.  File will then be updated and emailed."}]

{"sheet":"ABA Format","index":2,"n_rows":88,"n_cols":4,"rows_kept":88,"cut":false,"hidden":true,"merged":[[11,0,11,3],[37,0,43,0],[37,1,43,1],[37,2,43,2],[46,0,50,0],[46,1,50,1],[46,2,50,2],[18,0,19,0],[18,1,19,1],[18,2,19,2],[27,0,27,3],[34,0,36,0],[34,1,36,1],[34,2,36,2],[51,0,52,0],[51,1,52,1],[51,2,52,2],[53,0,54,0],[53,1,54,1],[87,1,87,3],[58,0,58,3],[72,0,72,3],[78,1,78,3],[79,1,79,3],[80,1,80,3],[81,1,81,3],[76,0,76,3],[82,1,82,3],[83,1,83,3],[84,1,84,3],[85,1,85,3],[86,1,86,3]]}
[]
[]
["ABA Format File Details"]
[]
["Issued by the Australian Bankers Association (ABA) the ABA or Cemtext file format is a format used by banks to allow for batch transactions."]
[]
[]
["ABA FILE FORMAT"]
[]
["What does an ABA file look like?"]
[]
["Each line in an ABA file is a \"record\". An ABA file has three main records, the \"descriptive\" record, a \"detail\" record for each transaction and the \"file total record\" at the end. The first character position of each new record indicates what type of record it is. An ABA record is exactly 120 characters long (excluding new line characters)."]
[]
["Descriptive record (type 0)"]
[]
["Char Pos","Field Size","Field Description","Specification"]
[1,1,"Record Type 0","Must be '0'"]
["2018-02-01",17,"Blank","Must be filled."]
["19-20",2,"Reel Sequence Number","Must be numeric commencing at 01. "]
[null,null,null,"Right justified. Zero filled."]
["21-23",3,"Name of User's Financial Institution","Must be approved Financial Institution abbreviation. Bank of Queensland's abbreviation is BQL, Westpac's abbreviation is \"WBC\". Consult your Bank for correct abbreviation."]
["24-30",7,"Blank","Must be blank filled."]
["31-56",26,"Name of Use supplying file","Must be User Preferred Specification as advised by User's FI. Left justified, blank filled. All coded character set valid. Must not be all blanks."]
["57-62",6,"Name of Use supplying file","Must be User Identification Number which is allocated by APCA. Must be numeric, right justified, zero filled."]
["63-74",12,"Description of entries on file e.g. \"PAYROLL\"","All coded character set valid. Must not be all blanks. Left justified, blank filled."]
["75-80",6,"Date to be processed (i,e. the date transactions are released to all Financial Institutions)","Must be numeric in the formal of DDMMYY. Must be a valid date. Zero filled."]
["81-120",40,"Blank","Must be blank filled."]
["Note: all unused fields must be blank filled"]
[]
["Detail Record (type 1)"]
[]
["Char Pos","Field Size","Field Description","Specification"]
[1,1,"Record Type 1","Must be '1'"]
["2-8",7,"Bank/State/Branch Number","Must be numeric with hyphen in character position 5. Character positions 2 and 3 must equal valid Financial Institution number. Character position 4 must equal a valid state number (0-9). For credits to Employee Benefits Card accounts, field must always contain BSB 032-898"]
["9-17",9,"Account number to be credited/debited","Numeric, hyphens and blanks only are valid. Must not contain all blanks (unless a credit card transaction) or zeros. Leading zeros which are part of a valid account number must be shown, e.g. 00-1234."]
[]
[null,null,null,"Where account number exceeds nine characters, edit out hyphens. Right justified, blank filled. For credits to Employee Benefits Card accounts, Account Number field must always be 999999"]
[18,1,"Indicator","\"N\" – for new or varied Bank/State/Branch number or name details, otherwise blank filled."]
[null,null,null,"Withholding Tax Indicators:"]
[null,null,null,"\"W\" – dividend paid to a resident of a country where a double tax agreement is in force."]
[null,null,null,"\"X\" – dividend paid to a resident of any other country."]
[null,null,null,"\"Y\" – interest paid to all non-residents."]
[null,null,null,"The amount of withholding tax is to appear in character positions 113-120."]
[null,null,null,"Note: Where withholding tax has been deducted the appropriate Indicator as shown above is to be used and will override the normal indicator."]
["19-20",2,"Transaction Code","For most transactions this will be 53. A full list of compatible transaction codes are listed below."]
["21-30",10,"Amount","Only numeric valid. Must be greater than zero. Shown in cents without punctuations. Right justified, zero filled. Unsigned."]
["31-62",32,"Title of Account to be credited/debited","All coded character set valid. Must not be all blanks. Left justified, blank filled."]
[null,null,null,"Desirable Format for Transaction Account credits:"]
[null,null,null,"   -  Surname (period)"]
[null,null,null,"       Blank"]
[null,null,null,"   -  given name with blanks between each name"]
["63-80",18,"Lodgement Reference","All coded character set valid. Field must be left justified, and contain only the 16 character Employee Benefits Card number; for example 5550033890123456."]
[null,null,null,"No leading spaces, zeroes, hyphens or other characters can be included."]
["81-87",7,"Trace Record ","Bank (FI)/State/Branch and account number of User to enable retracing of the entry to its source if necessary. Only numeric and hyphens valid. Character positions 81 & 82 must equal a valid Financial Institution number. Character position 83 must equal a valid State number (0-9). Character position 84 must be a hyphen."]
[null,null,"(BSB Number in format XXX-XXX)"]
["88-96",9,"(Account number)","Right justified, blank filled."]
["97-112",16,"Name of Remitter","Name of originator of the entry. This may vary from Name of the User. All coded character set valid. Must not contain all blanks. Left justified, blank filled."]
["113-120",8,"Amount of Withholding Tax","Numeric only valid. Show in cents without punctuation. Right justified, zero filled. Unsigned."]
["Note: all fields must be completed"]
[]
["File Total Record (type 7)"]
[]
["Char Pos","Field Size","Field Description","Specification"]
[1,1,"Record Type 7","Must be '7'"]
["2-8",7,"BSB Format Filler","Must be '999-999'"]
["9-20",12,"Blank","Must be blank filled."]
["21-30",10,"File (User) Net Total Amount","Numeric only valid. Must equal the difference between File Credit & File Debit Total Amounts. Show in cents without punctuation. Right justified, zero filled. Unsigned."]
["31-40",10,"File (User) Credit Total Amount","Numeric only valid. Must equal the accumulated total of credit Detail Record amounts. Show in cents without punctuation. Right justified, zero filled. Unsigned."]
["41-50",10,"File (User) Debit Total Amount","Numeric only valid. Must equal the accumulated total of debit Detail Record amounts. Show in cents without punctuation. Right justified, zero filled. Unsigned."]
["51-74",24,"Blank","Must be blank filled."]
["75-80",6,"File (user) count of Records Type 1","Numeric only valid. Must equal accumulated number of Record Type 1 items on the file. Right justified, zero filled."]
["81-120",40,"Blank","Must be blank filled."]
["Note: all unused fields must be blank filled"]
[]
["Transaction codes"]
[]
["Generally you only need to use the transaction code \"53 - Pay\" in your ABA file, however valid codes are as follows. Note that some transaction codes are debits and others are credits, and some require withholding tax column to be filled."]
[]
["Code","Transaction Description"]
[13,"Externally initiated debit items"]
[50,"Externally initiated credit items with the exception of those bearing Transaction Codes"]
[51,"Australian Government Security Interest"]
[52,"Family Allowance"]
[53,"Pay"]
[54,"Pension"]
[55,"Allotment"]
[56,"Dividend"]
[57,"Debenture/Note Interest"]